﻿<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="PlaceSelector.ascx.cs" Inherits="whatpricemyhouse.Controller.PlaceSelector" %>
<asp:DropDownList ID="PlaceDropList" runat="server" 
    DataSourceID="SqlDataSource1" DataTextField="suburb" 
    DataValueField="suburbid">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:WhatPriceMyHouseConnectionString %>" 
    SelectCommand="SELECT * FROM suburbs WHERE (area LIKE @area)">
    <SelectParameters>
        <asp:SessionParameter DefaultValue="auckland" Name="area" 
            SessionField="areaName" />
    </SelectParameters>
</asp:SqlDataSource>


